C:\Users\Shawn Weeks>mysql mysql -u root -p
Enter password: ****
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.2.2-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mysql]> show global variables like 'tmp_table_size';
+----------------+----------+
| Variable_name  | Value    |
+----------------+----------+
| tmp_table_size | 16777216 |
+----------------+----------+
1 row in set (0.00 sec)

MariaDB [mysql]> set global tmp_table_size=67108864;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> show global variables like 'tmp_table_size';
+----------------+----------+
| Variable_name  | Value    |
+----------------+----------+
| tmp_table_size | 67108864 |
+----------------+----------+
1 row in set (0.00 sec)

MariaDB [mysql]>
MariaDB [mysql]> show global variables like 'max_heap_table_size';
+---------------------+----------+
| Variable_name       | Value    |
+---------------------+----------+
| max_heap_table_size | 16777216 |
+---------------------+----------+
1 row in set (0.00 sec)

MariaDB [mysql]> set global max_heap_table_size=67108864;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> show global variables like 'max_heap_table_size';
+---------------------+----------+
| Variable_name       | Value    |
+---------------------+----------+
| max_heap_table_size | 67108864 |
+---------------------+----------+
1 row in set (0.00 sec)

MariaDB [mysql]>
MariaDB [mysql]> drop table if exists test_table;
Query OK, 0 rows affected (0.02 sec)

MariaDB [mysql]>
MariaDB [mysql]> create table test_table (id int, test_data varchar(36)) engine=innodb;
Query OK, 0 rows affected (0.04 sec)

MariaDB [mysql]>
MariaDB [mysql]> insert into test_table(id, test_data)
    -> select id, test_data
    ->     from (
    ->         with recursive data_generator(id, test_data) as (
    ->                 select 1 as id, uuid() as test_data
    ->                 union all
    ->                 select id + 1, uuid() from data_generator where id < 500000
    ->             )
    ->         select * from data_generator
    ->     ) as a;
ERROR 1114 (HY000): The table 'C:\WINDOWS\SERVIC~2\NETWOR~1\AppData\Local\Temp\#sql1498_2_4' is full
MariaDB [mysql]>
MariaDB [mysql]> commit;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]>